SyPaymentAccount_Proxy

Logical Entity Name | SyPaymentAccount_Proxy
Default Table Name | SyPaymentAccount_Proxy
Physical Only | NO
Owner | dbo
Definition |
Note |

SyPaymentAccount_Proxy Columns

ColumnName | Domain | Datatype | NULL | Definition
SyPaymentAccount_ProxyID |  | int | NO |
RecordID |  | int | NO |
OldCode |  | char(8) | YES |
NewCode |  | char(8) | YES |
OldDescrip |  | varchar(50) | YES |
NewDescrip |  | varchar(50) | YES |
OldPartner |  | varchar(50) | YES |
NewPartner |  | varchar(50) | YES |
OldVendorID |  | varchar(50) | YES |
NewVendorID |  | varchar(50) | YES |
OldSchoolUserID |  | varchar(50) | YES |
NewSchoolUserID |  | varchar(50) | YES |
OldSchoolPassword |  | varchar(130) | YES |
NewSchoolPassword |  | varchar(130) | YES |
OldTransFeeType |  | char(1) | YES |
NewTransFeeType |  | char(1) | YES |
OldTransFeeNum |  | numeric(12, 2) | YES |
NewTransFeeNum |  | numeric(12, 2) | YES |
OldTransFeeMin |  | numeric(12, 2) | YES |
NewTransFeeMin |  | numeric(12, 2) | YES |
OldTransFeeMax |  | numeric(12, 2) | YES |
NewTransFeeMax |  | numeric(12, 2) | YES |
OldTransFeeSource |  | char(1) | YES |
NewTransFeeSource |  | char(1) | YES |
OldTransFeeSaBillCodeID |  | int | YES |
NewTransFeeSaBillCodeID |  | int | YES |
OldTransMin |  | numeric(12, 2) | YES |
NewTransMin |  | numeric(12, 2) | YES |
OldTransMax |  | numeric(12, 2) | YES |
NewTransMax |  | numeric(12, 2) | YES |
OldTestMode |  | bit | YES |
NewTestMode |  | bit | YES |
OldPasswdRandomKey |  | varchar(258) | YES |
NewPasswdRandomKey |  | varchar(258) | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
OldSyPaymentProcessorID |  | int | YES |
NewSyPaymentProcessorID |  | int | YES |
OldAuthAmount |  | money | YES |
NewAuthAmount |  | money | YES |

SyPaymentAccount_Proxy Primary and Unique Keys

Key Name | Key Type | Keys
PK_SyPaymentAccount_Proxy_SyPaymentAccount_ProxyID | PrimaryKey | SyPaymentAccount_ProxyID

SyPaymentAccount_Proxy Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

SyPaymentAccount_Proxy Check Constraints

Check Constraint Name | CheckConstraint

SyPaymentAccount_Proxy Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SyPaymentAccount_Proxy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SyPaymentAccount_Proxy | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyPaymentAccount_Proxy | NO |  |  |

SyPaymentAccount_Proxy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

SyPaymentAccount_Proxy Data Movement Rules

Name | Type | Rule Text/Value